alter table Vacancies add IsArchive bit not null default(0)
go

alter table Vacancies add Comment1 ntext null 
go

alter table Vacancies add DLC datetime null 
go